use IstoreInternet;
--insert dates for table dbo.Attribute through stored procedure dbo.InsertAttribute
/*go
exec InsertAttribute @attrName = 'Screen', @attrDescription = 'Screen diagonal';
go
exec InsertAttribute @attrName = 'CPU', @attrDescription = 'Processor model i nazvanie';
go
exec InsertAttribute @attrName = 'RAM', @attrDescription = 'Operativnaya pamyati v Mb';
go
exec InsertAttribute @attrName = 'Type RAM', @attrDescription = 'RAM type(DDR)';
go
exec InsertAttribute @attrName = 'Castota CPU', @attrDescription = 'Castota CPU v GHz';
go
exec InsertAttribute @attrName = 'Manufacturer', @attrDescription = 'Device Manufacturer';
go
exec InsertAttribute @attrName = 'Resolution', @attrDescription = 'Device Resolution screen';
go
exec InsertAttribute @attrName = 'HDD', @attrDescription = 'HDD volume';
go
exec InsertAttribute @attrName = 'GRAM', @attrDescription = 'Graphics manufacturer';
go
exec InsertAttribute @attrName = 'Network adapter', @attrDescription = 'Network adapter';
go
exec InsertAttribute @attrName = 'Optical drive', @attrDescription = 'Optical drive DVD/CD';
go
exec InsertAttribute @attrName = 'Operating system', @attrDescription = 'Operating system(Windows, Linux, Mac)';
go
exec InsertAttribute @attrName = 'Weight', @attrDescription = 'Device weight';
go
exec InsertAttribute @attrName = 'Color', @attrDescription = 'Device color';
go
select * from dbo.Attribute;

--insert dates for table dbo.AttrValue through stored procedure dbo.InsertAttrValue
go
exec InsertAttrValue @attrName = 'Screen', @attrValueName = '10.1', @attrValueDescription = 'Standart netbook screen';
go
exec InsertAttrValue @attrName = 'Screen', @attrValueName = '14.4', @attrValueDescription = 'Wide netbook screen';
go
exec InsertAttrValue @attrName = 'Screen', @attrValueName = '15.6', @attrValueDescription = 'Standart notebook screen';
go
exec InsertAttrValue @attrName = 'Screen', @attrValueName = '17.3', @attrValueDescription = 'Wide notebook screen';
go
exec InsertAttrValue @attrName = 'Screen', @attrValueName = '18.4', @attrValueDescription = 'Very Wide notebook screen';
go
exec InsertAttrValue @attrName = 'CPU', @attrValueName = 'Intel Core i7', @attrValueDescription = 'Intel Core i7';
go
exec InsertAttrValue @attrName = 'CPU', @attrValueName = 'Intel Core i5', @attrValueDescription = 'Intel Core i5';
go
exec InsertAttrValue @attrName = 'CPU', @attrValueName = 'Intel Core i3', @attrValueDescription = 'Intel Core i3';
go
exec InsertAttrValue @attrName = 'CPU', @attrValueName = 'Intel Core M', @attrValueDescription = 'Intel Core M';
go
exec InsertAttrValue @attrName = 'CPU', @attrValueName = 'Intel Pentium', @attrValueDescription = 'Intel Pentium';
go
exec InsertAttrValue @attrName = 'CPU', @attrValueName = 'Intel Atom', @attrValueDescription = 'Intel Atom';
go
exec InsertAttrValue @attrName = 'CPU', @attrValueName = 'AMD FX', @attrValueDescription = 'AMD FX';
go
exec InsertAttrValue @attrName = 'CPU', @attrValueName = 'AMD E', @attrValueDescription = 'AMD E';
go
exec InsertAttrValue @attrName = 'CPU', @attrValueName = 'AMD A10', @attrValueDescription = 'AMD A10';
go
exec InsertAttrValue @attrName = 'CPU', @attrValueName = 'AMD A8', @attrValueDescription = 'AMD A8';
go
exec InsertAttrValue @attrName = 'CPU', @attrValueName = 'AMD A6', @attrValueDescription = 'AMD A6';
go
exec InsertAttrValue @attrName = 'CPU', @attrValueName = 'AMD A4', @attrValueDescription = 'AMD A4';
go
exec InsertAttrValue @attrName = 'CPU', @attrValueName = 'Intel Celeron N2840', @attrValueDescription = 'Intel Celeron N2840';
go
exec InsertAttrValue @attrName = 'RAM', @attrValueName = '1024', @attrValueDescription = '1024Mb';
go
exec InsertAttrValue @attrName = 'RAM', @attrValueName = '512', @attrValueDescription = '512Mb';
go
exec InsertAttrValue @attrName = 'RAM', @attrValueName = '2048', @attrValueDescription = '2048Mb';
go
exec InsertAttrValue @attrName = 'RAM', @attrValueName = '4096', @attrValueDescription = '4096Mb';
go
exec InsertAttrValue @attrName = 'RAM', @attrValueName = '8192', @attrValueDescription = '8192Mb';
go
exec InsertAttrValue @attrName = 'RAM', @attrValueName = '16386', @attrValueDescription = '16386Mb';
go
exec InsertAttrValue @attrName = 'Type RAM', @attrValueName = 'DDR3 SDRAM', @attrValueDescription = 'DDR3‑1600';
go
exec InsertAttrValue @attrName = 'Type RAM', @attrValueName = 'DDR3 SDRAM', @attrValueDescription = 'DDR3‑1600';
go
exec InsertAttrValue @attrName = 'Type RAM', @attrValueName = 'DDR3 SDRAM', @attrValueDescription = 'DDR3‑1600';
go
exec InsertAttrValue @attrName = 'Type RAM', @attrValueName = 'DDR3 SDRAM', @attrValueDescription = 'DDR3‑1600';
go
exec InsertAttrValue @attrName = 'Type RAM', @attrValueName = 'DDR3 SDRAM', @attrValueDescription = 'DDR3‑1600';
go
exec InsertAttrValue @attrName = 'Castota CPU', @attrValueName = '2.4GHz', @attrValueDescription = '2.4GHz';
go
exec InsertAttrValue @attrName = 'Manufacturer', @attrValueName = 'Acer', @attrValueDescription = 'Acer';
go
exec InsertAttrValue @attrName = 'Manufacturer', @attrValueName = 'Apple', @attrValueDescription = 'Acer';
go
exec InsertAttrValue @attrName = 'Manufacturer', @attrValueName = 'Asus', @attrValueDescription = 'Acer';
go
exec InsertAttrValue @attrName = 'Manufacturer', @attrValueName = 'Dell', @attrValueDescription = 'Acer';
go
exec InsertAttrValue @attrName = 'Manufacturer', @attrValueName = 'HP', @attrValueDescription = 'Acer';
go
exec InsertAttrValue @attrName = 'Manufacturer', @attrValueName = 'Acer', @attrValueDescription = 'Acer';
go
exec InsertAttrValue @attrName = 'Resolution', @attrValueName = '800 x 600', @attrValueDescription = 'SVGA';
go
exec InsertAttrValue @attrName = 'Resolution', @attrValueName = '1024 x 768', @attrValueDescription = 'XGA';
go
exec InsertAttrValue @attrName = 'Resolution', @attrValueName = '1152 x 768', @attrValueDescription = 'WVGA';
go
exec InsertAttrValue @attrName = 'Resolution', @attrValueName = '1280 x 768', @attrValueDescription = 'WVGA';
go
exec InsertAttrValue @attrName = 'Resolution', @attrValueName = '1280 x 800', @attrValueDescription = 'WVGA';
go
exec InsertAttrValue @attrName = 'Resolution', @attrValueName = '1280 x 854', @attrValueDescription = 'WSVGA';
go
exec InsertAttrValue @attrName = 'Resolution', @attrValueName = '1280 x 960', @attrValueDescription = 'SXGA';
go
exec InsertAttrValue @attrName = 'Resolution', @attrValueName = '1280 x 1024', @attrValueDescription = 'SXGA';
go
exec InsertAttrValue @attrName = 'Resolution', @attrValueName = '1440 x 900', @attrValueDescription = 'WXGA+';
go
exec InsertAttrValue @attrName = 'Resolution', @attrValueName = '1400 x 1050', @attrValueDescription = 'SXGA+';
go
exec InsertAttrValue @attrName = 'Resolution', @attrValueName = '1680 x 1050', @attrValueDescription = 'WSXGA+';
go
exec InsertAttrValue @attrName = 'Resolution', @attrValueName = '1600 x 1200', @attrValueDescription = 'UXGA';
go
exec InsertAttrValue @attrName = 'Resolution', @attrValueName = '1920 x 1200', @attrValueDescription = 'WUXGA';
go
exec InsertAttrValue @attrName = 'Resolution', @attrValueName = '2048 x 1536', @attrValueDescription = 'QXGA';
go
exec InsertAttrValue @attrName = 'HDD', @attrValueName = '500', @attrValueDescription = '500Gb';
go
exec InsertAttrValue @attrName = 'HDD', @attrValueName = '320', @attrValueDescription = '320Gb';
go
exec InsertAttrValue @attrName = 'HDD', @attrValueName = '750', @attrValueDescription = '750Gb';
go
exec InsertAttrValue @attrName = 'HDD', @attrValueName = '1000', @attrValueDescription = '1Tb';
go
exec InsertAttrValue @attrName = 'GRAM', @attrValueName = 'Intel HD Graphics', @attrValueDescription = 'Intel HD Graphics';
go
exec InsertAttrValue @attrName = 'GRAM', @attrValueName = 'AMD FirePro', @attrValueDescription = 'AMD FirePro';
go
exec InsertAttrValue @attrName = 'GRAM', @attrValueName = 'AMD Radeon', @attrValueDescription = 'AMD Radeon';
go
exec InsertAttrValue @attrName = 'GRAM', @attrValueName = 'nVidia GeForce', @attrValueDescription = 'nVidia GeForce';
go
exec InsertAttrValue @attrName = 'GRAM', @attrValueName = 'nVidia Quadro', @attrValueDescription = 'nVidia Quadro';
go
exec InsertAttrValue @attrName = 'Network adapter', @attrValueName = 'Bluetooth 4.0', @attrValueDescription = 'Bluetooth 4.0';
go
exec InsertAttrValue @attrName = 'Network adapter', @attrValueName = 'Gigabit Ethernet', @attrValueDescription = 'Gigabit Ethernet';
go
exec InsertAttrValue @attrName = 'Network adapter', @attrValueName = 'Wi-Fi 802.11 b/g/n', @attrValueDescription = 'Wi-Fi 802.11 b/g/n';
go
exec InsertAttrValue @attrName = 'Network adapter', @attrValueName = 'Wi-Fi 802.11 b/', @attrValueDescription = 'Wi-Fi 802.11 b/';
go
exec InsertAttrValue @attrName = 'Network adapter', @attrValueName = 'Wi-Fi 802.11 g/', @attrValueDescription = 'Wi-Fi 802.11 g/';
go
exec InsertAttrValue @attrName = 'Network adapter', @attrValueName = 'Wi-Fi 802.11 n/', @attrValueDescription = 'Wi-Fi 802.11 n/';
go
exec InsertAttrValue @attrName = 'Optical drive', @attrValueName = 'DVD Super Multi', @attrValueDescription = 'DVD Super Multi';
go
exec InsertAttrValue @attrName = 'Operating system', @attrValueName = 'Windows 7', @attrValueDescription = 'Windows 7';
go
exec InsertAttrValue @attrName = 'Operating system', @attrValueName = 'Ubuntu 14.10', @attrValueDescription = 'Ubuntu 14.10';
go
exec InsertAttrValue @attrName = 'Operating system', @attrValueName = 'MAC OS', @attrValueDescription = 'MAC OS';
go
exec InsertAttrValue @attrName = 'Color', @attrValueName = 'Black', @attrValueDescription = 'Black';
go
exec InsertAttrValue @attrName = 'Color', @attrValueName = 'White', @attrValueDescription = 'White';
go
exec InsertAttrValue @attrName = 'Color', @attrValueName = 'Red', @attrValueDescription = 'Red';

go

select * from dbo.AttrValue;
--insert dates for table dbo.CityOrRegion through stored procedure dbo.InsertCityOrRegion
go
exec InsertCityOrRegion @cityOrRegionName = 'Kishinev';
go
exec InsertCityOrRegion @cityOrRegionName = 'Komrat';
go
exec InsertCityOrRegion @cityOrRegionName = 'Belicy';
go
exec InsertCityOrRegion @cityOrRegionName = 'Kagul';
go
exec InsertCityOrRegion @cityOrRegionName = 'Hynceshty';
go
select * from dbo.CityOrRegion;

--insert dates for table dbo.Customer through stored procedure dbo.InsertCustomer
go
exec InsertCustomer @organisationOrPerson = 0, @organisationName = 'Moldinconbank', @gender = null, 
@firstName = 'Ivanov', @middleName = 'Ivan', @lastName = 'Ivanovici', @emailPost = 'ivanov.ivan@mail.ru', 
@phoneNumber = '022-951-369', @mobilePhoneNumber = '069-831-842', @dateOfBirth = '1985-05-13', 
@postIndex = 'MD-2025';
go
exec InsertCustomer @organisationOrPerson = 0, @organisationName = 'Mobiasbanka', @gender = null, 
@firstName = 'Petrov', @middleName = 'Petr', @lastName = 'Petrovici', @emailPost = 'petrov.petr@mail.ru', 
@phoneNumber = '022-951-369', @mobilePhoneNumber = '069-831-842', @dateOfBirth = '1985-07-13', 
@postIndex = 'MD-2026';
go
exec InsertCustomer @organisationOrPerson = 1, @organisationName = null, @gender = 'm', @firstName = 'Artemov'
, @middleName = 'Artem', @lastName = 'Artemovici', @emailPost = 'artem.artemovici@mail.ru', 
@phoneNumber = '022-951-369', @mobilePhoneNumber = '069-851-842', @dateOfBirth = '1980-05-13', @postIndex = 'MD-2125';
go
exec InsertCustomer @organisationOrPerson = 1, @organisationName = null, @gender = 'f', @firstName = 'Varvarov'
, @middleName = 'Varvara', @lastName = 'Vladimirivna', @emailPost = 'varvarov.varvara@mail.ru', 
@phoneNumber = '022-951-369', @mobilePhoneNumber = '078-831-842', @dateOfBirth = '1975-05-13', @postIndex = 'MD-4025';
go
exec InsertCustomer @organisationOrPerson = 0, @organisationName = 'Vinaria Bostavan', @gender = null, 
@firstName = 'Maximov', @middleName = 'Maxim', @lastName = 'Maximovici', @emailPost = 'maximov.maxim@mail.ru', 
@phoneNumber = '022-951-369', @mobilePhoneNumber = '069-831-842', @dateOfBirth = '1985-05-13', @postIndex = 'MD-2025';
go
select * from dbo.Customer;

--insert dates for table dbo.CustomerAccount through stored procedure dbo.InsertCustomerAccount
go
exec InsertCustomerAccount @customerId = 1, @loginCustomer = 'ivanov.ivan', @passwordCustomer = 'ivanov.ivan12345';
go
exec InsertCustomerAccount @customerId = 2, @loginCustomer = 'petrov.petr', @passwordCustomer = 'petrov.petr12345';
go
exec InsertCustomerAccount @customerId = 3, @loginCustomer = 'artem.artemovici', @passwordCustomer = 'artem.artemovici12345';
go
exec InsertCustomerAccount @customerId = 4, @loginCustomer = 'varvarov.varvara', @passwordCustomer = 'varvarov.varvara12345';
go
exec InsertCustomerAccount @customerId = 5, @loginCustomer = 'maximov.maxim', @passwordCustomer = 'maximov.maxim12345';
go
select * from dbo.CustomerAccount;

--insert dates for table dbo.CustomerAddress through stored procedure dbo.InsertCustomerAddress
go
exec InsertCustomerAddress @customerId = 1, @cityOrRegionId = 1, @address = 'Stefan cel Mare, 15';
go
exec InsertCustomerAddress @customerId = 2, @cityOrRegionId = 2, @address = 'Puskin, 18/9';
go
exec InsertCustomerAddress @customerId = 3, @cityOrRegionId = 3, @address = 'Calea Ieshilor, 18';
go
exec InsertCustomerAddress @customerId = 4, @cityOrRegionId = 4, @address = 'Alba Ulia, 12';
go
exec InsertCustomerAddress @customerId = 5, @cityOrRegionId = 5, @address = '31 avgust, 13';
go
select * from dbo.CustomerAddress;

--insert dates for table dbo.Order through stored procedure dbo.InsertOrder
/*go
exec InsertOrder @customerId = 1, @orderStatusCode = 'zakaz', @orderState = 'obrabatyvaetsya', @orderDetails = 'vash zakaz obrabatyvaetsya skoro pomenyaetsya status';
go
exec InsertOrder @customerId = 2, @orderStatusCode = 'zakaz', @orderState = 'obrabatyvaetsya', @orderDetails = 'vash zakaz obrabatyvaetsya skoro pomenyaetsya status';
go
exec InsertOrder @customerId = 3, @orderStatusCode = 'zakaz', @orderState = 'obrabatyvaetsya', @orderDetails = 'vash zakaz obrabatyvaetsya skoro pomenyaetsya status';
go
exec InsertOrder @customerId = 4, @orderStatusCode = 'zakaz', @orderState = 'obrabatyvaetsya', @orderDetails = 'vash zakaz obrabatyvaetsya skoro pomenyaetsya status';
go
exec InsertOrder @customerId = 5, @orderStatusCode = 'zakaz', @orderState = 'obrabatyvaetsya', @orderDetails = 'vash zakaz obrabatyvaetsya skoro pomenyaetsya status';
go
select * from dbo.[Order];*/

--insert dates for table dbo.PaymentMethod through stored procedure dbo.InsertPaymentMethod
go
exec InsertPaymentMethod @paymentMethodDescription = 'Nalicnye pri polucenii';
go
exec InsertPaymentMethod @paymentMethodDescription = 'Bankovkaya karta';
go
exec InsertPaymentMethod @paymentMethodDescription = 'Web money';
go
exec InsertPaymentMethod @paymentMethodDescription = 'Qiwi';
go
exec InsertPaymentMethod @paymentMethodDescription = 'Electronnymi denigami';
go
select * from dbo.PaymentMethod;

--insert dates for table dbo.ProductRatingItem through stored procedure dbo.InsertProductRatingItem
go
exec InsertProductRatingItem @rating = '1';
go
exec InsertProductRatingItem @rating = '2';
go
exec InsertProductRatingItem @rating = '3';
go
exec InsertProductRatingItem @rating = '4';
go
exec InsertProductRatingItem @rating = '5';
go
select * from dbo.ProductRatingItem;

--insert dates for table dbo.ProductType through stored procedure dbo.InsertProductType
go
exec InsertProductType @productTypeName = 'Notebook', @productTypeDescription = 'Notebooks';
go
exec InsertProductType @productTypeName = 'Desktop', @productTypeDescription = 'Nastolinyi kompyuter';
go
exec InsertProductType @productTypeName = 'Mobilinye telefony', @productTypeDescription = 'Mobilinye telefony';
go
exec InsertProductType @productTypeName = 'RAM', @productTypeDescription = 'Operativnaya pamyati';
go
exec InsertProductType @productTypeName = 'CPU', @productTypeDescription = 'Processory';
go
select * from dbo.ProductType;

--insert dates for table dbo.ProductTypeAttrValue through stored procedure dbo.InsertProductTypeAttrValue
/*go
exec InsertProductTypeAttrValue @productTypeId = 1, @attrValueId = 1;
go
exec InsertProductTypeAttrValue @productTypeId = 1, @attrValueId = 2;
go
exec InsertProductTypeAttrValue @productTypeId = 1, @attrValueId = 3;
go
exec InsertProductTypeAttrValue @productTypeId = 1, @attrValueId = 4;
go
exec InsertProductTypeAttrValue @productTypeId = 1, @attrValueId = 5;
go
select * from dbo.ProductTypeAttrValue;*/

--insert dates for table dbo.WishList through stored procedure dbo.InsertWishList
/*go
exec InsertWishList @customerId = 1;
go
exec InsertWishList @customerId = 2;
go
exec InsertWishList @customerId = 3;
go
exec InsertWishList @customerId = 4;
go
exec InsertWishList @customerId = 5;
go*/
select * from dbo.WishList;

--insert dates for table dbo.CustomerPaymentMethod through stored procedure dbo.InsertCustomerPaymentMethod
/*go
exec InsertCustomerPaymentMethod @paymentMethodId = 1, @customerId = 2, @paymentDetails = '';
go
exec InsertCustomerPaymentMethod @paymentMethodId = 2, @customerId = 1, @paymentDetails = '';
go
exec InsertCustomerPaymentMethod @paymentMethodId = 3, @customerId = 3, @paymentDetails = '';
go
exec InsertCustomerPaymentMethod @paymentMethodId = 3, @customerId = 4, @paymentDetails = '';
go
exec InsertCustomerPaymentMethod @paymentMethodId = 1, @customerId = 5, @paymentDetails = '';
go
select * from dbo.CustomerPaymentMethod;*/

--insert dates for table dbo.Invoice through stored procedure dbo.InsertInvoice
/*go
exec InsertInvoice @orderId = 1, @invoiceDate = '2013-02-25', @invoiceDetails = '';
go
exec InsertInvoice @orderId = 2, @invoiceDate = '2014-12-31', @invoiceDetails = '';
go
exec InsertInvoice @orderId = 3, @invoiceDate = '2015-01-25', @invoiceDetails = '';
go
exec InsertInvoice @orderId = 4, @invoiceDate = '2015-01-25', @invoiceDetails = '';
go
exec InsertInvoice @orderId = 5, @invoiceDate = '2014-08-25', @invoiceDetails = '';
go
select * from dbo.Invoice;*/

--insert dates for table dbo.Payment through stored procedure dbo.InsertPayment
/*go
exec InsertPayment @invoiceNumber = 1, @paymentDate = '2014-07-25', @paymentAmount = 6000;
go
exec InsertPayment @invoiceNumber = 2, @paymentDate = '2014-08-25', @paymentAmount = 6000;
go
exec InsertPayment @invoiceNumber = 3, @paymentDate = '2014-09-25', @paymentAmount = 6000;
go
exec InsertPayment @invoiceNumber = 4, @paymentDate = '2014-10-25', @paymentAmount = 6000;
go
exec InsertPayment @invoiceNumber = 5, @paymentDate = '2014-02-25', @paymentAmount = 6000;
go
select * from dbo.Payment;*/

--insert dates for table dbo.Product through stored procedure dbo.InsertProduct
go
exec InsertProduct @productTypeId = 1, @productName = 'Acer Aspire E1-532G', @productDescription = '"NB Acer 15.6"" Aspire E1-532G-35564G75Mnkk (Pentium 3556U 4Gb 750Gb)
15.6"" HD (1366x768) Glare, Intel Pentium 3556U (2x Core, 1.7GHz, 2Mb), 4Gb (1x 4Gb) PC3-12800, 750Gb 5400rpm, Radeon HD 8670M 1Gb, HDMI, DVD-RW, Gbit NIC, 802.11bgn, 1x USB 3.0, 2x USB 2.0, Card Reader, 1.3MP Webcam, Linux, 4-cell 2500mAh Li-Ion Battery, 2.35kg, Black"',
@productPrice = 8590, @productSmallImage = null, @productMiddleImage = null, @productBigImage = null, @productWarranty = 12;
go
exec InsertProduct @productTypeId = 1, @productName = 'Acer Aspire E5-511--P9D8 Black', @productDescription = '"NB Acer 15.6"" Aspire E5-511-P9D8 Black (Pentium N3540 4Gb 500Gb)
15.6"" HD (1366x768) Glare, Intel Pentium N3540 (4x Core, 2.16GHz, 2Mb), 4Gb (1x 4Gb) PC3-12800, 500Gb 5400rpm, Intel HD Graphics, HDMI, DVD-RW, Gbit NIC, 802.11bgn, 1x USB 3.0, 2x USB 2.0, Card Reader, HD Webcam, Linux, 6-cell 2500mAh Li-Ion Battery, 2.5kg, Black"',
@productPrice = 7560, @productSmallImage = null, @productMiddleImage = null, @productBigImage = null, @productWarranty = 12;
go
exec InsertProduct @productTypeId = 1, @productName = 'Apple MacBook Air MD761RS/B', @productDescription = 'Apple MacBook Air MD761RS/B (13.3"" i5 1.4GHz 4Gb 256Gb)
13.3'' 1440x900, Core i5 1.4GHz, 4Gb, 256Gb, Intel HD 5000, Mac OS X 10.9 Mavericks, RU"',
@productPrice = 29000, @productSmallImage = null, @productMiddleImage = null, @productBigImage = null, @productWarranty = 12;
go
exec InsertProduct @productTypeId = 1, @productName = 'Asus X551MA Black', @productDescription = '"NB ASUS 15.6"" X551MA Black (Celeron N2815 4Gb 500Gb Win 8)
15.6"" HD (1366x768) Glare, Intel Celeron N2815 (2x Core, 1.86GHz, 1Mb), 4Gb (1x 4Gb) PC3-12800, 500Gb 5400rpm, Intel HD Graphics, HDMI, DVD-RW, Gbit NIC, 802.11n, Bluetooth 4.0, 1x USB 3.0, 1x USB 2.0, Card Reader, HD Webcam, Windows 8 RU, 3-cell 3000mAh Li-Ion Battery, 2.15kg, Black"',
@productPrice = 6990, @productSmallImage = null, @productMiddleImage = null, @productBigImage = null, @productWarranty = 12;
go
exec InsertProduct @productTypeId = 1, @productName = 'Lenovo IdeaPad G50-30', @productDescription = '"NB Lenovo 15.6"" IdeaPad G50-30 (Pentium N3530 4Gb 500Gb)
15.6"" HD (1366x768) Glare, Intel Pentium N3530 (4x Core, 2.16GHz, 2Mb), 4Gb (1x 4Gb) PC3-12800, 500Gb 5400rpm, GeForce 820M 1Gb, HDMI, DVD-RW, Gbit NIC, Bluetooth 4.0, 802.11bgn, 1x USB 3.0, 2x USB 2.0, Card Reader, 0.3MP Webcam, DOS, 4-cell 32Wh Li-Ion Battery, 2.5kg, Black"',
@productPrice = 8590, @productSmallImage = null, @productMiddleImage = null, @productBigImage = null, @productWarranty = 12;
go
exec InsertProduct @productTypeId = 1, @productName = 'Asus X553MA', @productDescription = 'Экран 15.6" (1366x768) HD LED, глянцевый / Intel Celeron N2830 (2.16 ГГц) / RAM 4 ГБ / HDD 500 ГБ / Intel HD Graphics / DVD Super Multi / LAN / Bluetooth / Wi-Fi / веб-камера / DOS / 2.2 кг ',
@productPrice = 8290, @productSmallImage = null, @productMiddleImage = null, @productBigImage = null, @productWarranty = 12;
go
select * from dbo.Product;*/
--insert dates for table dbo.ProductAttrValue through stored procedure dbo.InsertProductAttrValue
go
exec InsertProductAttrValue @productName = 'Asus X553MA', @attrName = 1;
go
exec InsertProductAttrValue @productId = 2, @attrValueId = 1;
go
exec InsertProductAttrValue @productId = 3, @attrValueId = 1;
go
exec InsertProductAttrValue @productId = 4, @attrValueId = 1;
go
exec InsertProductAttrValue @productId = 5, @attrValueId = 1;
go
select * from dbo.ProductAttrValue;

--insert dates for table dbo.ProductComment through stored procedure dbo.InsertProductComment
go
exec InsertProductComment @productId = 5, @customerId = 1, @productComment = 'Good', 
@productCommentDignity = 'moshnyi', @productCommentShortcoming = 'dorogoi oceni';
go
exec InsertProductComment @productId = 1, @customerId = 1, @productComment = 'Good', 
@productCommentDignity = 'moshnyi', @productCommentShortcoming = 'dorogoi oceni';
go
exec InsertProductComment @productId = 3, @customerId = 1, @productComment = 'Good', 
@productCommentDignity = 'moshnyi', @productCommentShortcoming = 'dorogoi oceni';
go
exec InsertProductComment @productId = 2, @customerId = 1, @productComment = 'Good', 
@productCommentDignity = 'moshnyi', @productCommentShortcoming = 'dorogoi oceni';
go
exec InsertProductComment @productId = 2, @customerId = 2, @productComment = 'Good', 
@productCommentDignity = 'moshnyi', @productCommentShortcoming = 'dorogoi oceni';
go
select * from dbo.ProductComment;

--insert dates for table dbo.ProductPhoto through stored procedure dbo.InsertProductPhoto
go
exec InsertProductPhoto @productId = 2, @productPhoto = null;
go
exec InsertProductPhoto @productId = 1, @productPhoto = null;
go
exec InsertProductPhoto @productId = 3, @productPhoto = null;
go
exec InsertProductPhoto @productId = 5, @productPhoto = null;
go
exec InsertProductPhoto @productId = 4, @productPhoto = null;
go
select * from dbo.ProductPhoto;

--insert dates for table dbo.ProductWatchingStatistic through stored procedure dbo.InsertProductWatchingStatistic
go
exec InsertProductWatchingStatistic @productId = 4, @countWatching = 5;
go
exec InsertProductWatchingStatistic @productId = 1, @countWatching = 150;
go
exec InsertProductWatchingStatistic @productId = 2, @countWatching = 90;
go
exec InsertProductWatchingStatistic @productId = 3, @countWatching = 1;
go
exec InsertProductWatchingStatistic @productId = 5, @countWatching = 0;
go
select * from dbo.ProductWatchingStatistic;

--insert dates for table dbo.ProductRating through stored procedure dbo.InsertProductRating
go
exec InsertProductRating @productId = 5, @estimateCount = 0, @productRatingItemId = 5, @customerId = 1;
go
exec InsertProductRating @productId = 5, @estimateCount = 0, @productRatingItemId = 5, @customerId = 2;
go
exec InsertProductRating @productId = 5, @estimateCount = 0, @productRatingItemId = 5, @customerId = 3;
go
exec InsertProductRating @productId = 5, @estimateCount = 0, @productRatingItemId = 5, @customerId = 4;
go
exec InsertProductRating @productId = 5, @estimateCount = 0, @productRatingItemId = 5, @customerId = 5;
go
select * from dbo.ProductRating;

--insert dates for table dbo.Shipment through stored procedure dbo.InsertShipment
go
exec InsertShipment @orderId = 5, @invoiceNumber = 1, @shipmentStockNumber = 500, @shipmentDetails = '';
go
exec InsertShipment @orderId = 1, @invoiceNumber = 2, @shipmentStockNumber = 501, @shipmentDetails = '';
go
exec InsertShipment @orderId = 4, @invoiceNumber = 3, @shipmentStockNumber = 502, @shipmentDetails = '';
go
exec InsertShipment @orderId = 3, @invoiceNumber = 4, @shipmentStockNumber = 503, @shipmentDetails = '';
go
exec InsertShipment @orderId = 2, @invoiceNumber = 5, @shipmentStockNumber = 504, @shipmentDetails = '';
go
select * from dbo.Shipment;

--insert dates for table dbo.WishListProduct through stored procedure dbo.InsertWishListProduct
go
exec InsertWishListProduct @wishListId = 1, @productId = 2, @addedDate = '2014-11-15';
go
exec InsertWishListProduct @wishListId = 1, @productId = 3, @addedDate = '2014-11-15';
go
exec InsertWishListProduct @wishListId = 2, @productId = 1, @addedDate = '2014-11-15';
go
exec InsertWishListProduct @wishListId = 3, @productId = 4, @addedDate = '2014-11-15';
go
exec InsertWishListProduct @wishListId = 5, @productId = 1, @addedDate = '2014-11-15';
go
select * from dbo.WishListProduct;

--insert dates for table dbo.OrderItem through stored procedure dbo.InsertOrderItem
go
exec InsertOrderItem @productId = 1, @orderId = 1, @orderItemQuantity = 1, @orderItemPrice = 6000.00,
@RMANumber = null, @RMAIssuedBy = null, @RMAIssuedDate = null;
go
exec InsertOrderItem @productId = 2, @orderId = 2, @orderItemQuantity = 1, @orderItemPrice = 6000.00,
@RMANumber = null, @RMAIssuedBy = null, @RMAIssuedDate = null;
go
exec InsertOrderItem @productId = 3, @orderId = 3, @orderItemQuantity = 1, @orderItemPrice = 6000.00,
@RMANumber = null, @RMAIssuedBy = null, @RMAIssuedDate = null;
go
exec InsertOrderItem @productId = 4, @orderId = 4, @orderItemQuantity = 1, @orderItemPrice = 6000.00,
@RMANumber = null, @RMAIssuedBy = null, @RMAIssuedDate = null;
go
exec InsertOrderItem @productId = 5, @orderId = 5, @orderItemQuantity = 1, @orderItemPrice = 6000.00,
@RMANumber = null, @RMAIssuedBy = null, @RMAIssuedDate = null;
go
select * from dbo.OrderItem;

--insert dates for table dbo.ShipmentItem through stored procedure dbo.InsertShipmentItem
go
exec InsertShipmentItem @shipmentId = 1, @orderItemId = 1;
go
exec InsertShipmentItem @shipmentId = 2, @orderItemId = 2;
go
exec InsertShipmentItem @shipmentId = 3, @orderItemId = 3;
go
exec InsertShipmentItem @shipmentId = 4, @orderItemId = 4;
go
exec InsertShipmentItem @shipmentId = 5, @orderItemId = 5;
go
select * from dbo.ShipmentItem;

--insert dates for table dbo.ShoppingCart through stored procedure dbo.InsertShoppingCart
go
exec InsertShoppingCart @customerId = 5, @orderItemId = 5, @shipmentId = 1, @createDate = '2014-11-15';
go
exec InsertShoppingCart @customerId = 4, @orderItemId = 4, @shipmentId = 2, @createDate = '2014-11-15';
go
exec InsertShoppingCart @customerId = 3, @orderItemId = 3, @shipmentId = 3, @createDate = '2014-11-15';
go
exec InsertShoppingCart @customerId = 2, @orderItemId = 2, @shipmentId = 4, @createDate = '2014-11-15';
go
exec InsertShoppingCart @customerId = 1, @orderItemId = 1, @shipmentId = 5, @createDate = '2014-11-15';
go
select * from dbo.ShoppingCart;